BEGIN;

delete from win_common_names;
SELECT pg_catalog.setval('win_common_names_id_seq', 1, true);
delete from win_observation_images;
SELECT pg_catalog.setval('win_observation_images_id_seq', 1, true);
delete from win_scientific_name;
SELECT pg_catalog.setval('win_scientific_name_id_seq', 1, true);
delete from win_observation_location;
SELECT pg_catalog.setval('win_observation_location_id_seq', 1, true);
delete from win_validation;
SELECT pg_catalog.setval('win_validation_id_seq', 1, true);
delete from win_observations_partofday;
SELECT pg_catalog.setval('win_observations_partofday_id_seq', 1, true);
delete from win_observations cascade;
SELECT pg_catalog.setval('win_observations_id_seq', 1, true);
delete FROM win_observer where id > 0;
SELECT pg_catalog.setval('win_observer_id_seq', 1, true);

COMMIT;